﻿CREATE TABLE [dbo].[Ann]
(
	[id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [idWork] INT NOT NULL, 
    [dateTime] DATETIME NOT NULL, 
    [name] TEXT NOT NULL, 
    [idDataSet] INT NOT NULL, 
    [note] TEXT NOT NULL, 
    [param] TEXT NULL, 
    [test] TEXT NULL, 
    [testValues] TEXT NULL, 
    [data] IMAGE NOT NULL, 
    CONSTRAINT [FK_Ann_ToTable_2] FOREIGN KEY ([idWork]) REFERENCES [Work]([id]), 
    CONSTRAINT [FK_Ann_ToTable_1] FOREIGN KEY ([idDataSet]) REFERENCES [DataSet]([id]) 
    
)
